Query By Example - meaning and definition. What is Query By Example
Diclib.com
ChatGPT AI Dictionary
Enter a word or phrase in any language 👆
Language:

Translation and analysis of words by ChatGPT artificial intelligence

On this page you can get a detailed analysis of a word or phrase, produced by the best artificial intelligence technology to date:

  • how the word is used
  • frequency of use
  • it is used more often in oral or written speech
  • word translation options
  • usage examples (several phrases with translation)
  • etymology

What (who) is Query By Example - definition

DEVISED BY MOSHÉ M. ZLOOF AT IBM RESEARCH DURING THE MID-1970S
Query-by-Example; Query By Example; Query-by-example; Query by example
  • Example of QBE query with joins, designed in Borland's [[Paradox database]]

Query By Example         
<database, language> (QBE) A user-friendly query language developed by Moshé Zloof of IBM in 1975. Query By Exampleley/db/indices/a-tree/z/Zloof:Mosh=eacute=_M=.html">http://informatik.uni-trier.de/Query By Exampleley/db/indices/a-tree/z/Zloof:Mosh=eacute=_M=.html. [Moshé M. Zloof, "Query By Example", AFIPS NCC 1975: 431-438]. [Moshé M. Zloof, "Query-by-Example: A Data Base Language", IBM Systems Journal 16(4): 324-343, 1977]. ["QBE/OBE: A Language for Office and Business Automation", M.M. Zloof, Computer pp.13-22, May 1981]. (2001-03-25)
Query by Example         
Query by Example (QBE) is a database query language for relational databases. It was devised by Moshé M.
Microsoft Query         
METHOD OF CREATING DATABASE QUERIES
Microsoft QBE; Microsoft Query by Example; MS Query
Microsoft Query is a visual method of creating database queries using examples based on a text string, the name of a document or a list of documents. The QBE system converts the user input into a formal database query using Structured Query Language (SQL) on the backend, allowing the user to perform powerful searches without having to explicitly compose them in SQL, and without even needing to know SQL.

Wikipedia

Query by Example

Query by Example (QBE) is a database query language for relational databases. It was devised by Moshé M. Zloof at IBM Research during the mid-1970s, in parallel to the development of SQL. It is the first graphical query language, using visual tables where the user would enter commands, example elements and conditions. Many graphical front-ends for databases use the ideas from QBE today. Originally limited only for the purpose of retrieving data, QBE was later extended to allow other operations, such as inserts, deletes and updates, as well as creation of temporary tables.

The motivation behind QBE is that a parser can convert the user's actions into statements expressed in a database manipulation language, such as SQL. Behind the scenes, it is this statement that is actually executed. A suitably comprehensive front-end can minimize the burden on the user to remember the finer details of SQL, and it is easier and more productive for end-users (and even programmers) to select tables and columns by selecting them rather than typing in their names.

In the context of information retrieval, QBE has a somewhat different meaning. The user can submit a document, or several documents, and ask for "similar" documents to be retrieved from a document database [see search by multiple examples]. Similarity search is based comparing document vectors (see Vector Space Model).

QBE represents seminal work in end-user development, frequently cited in research papers as an early example of this topic.

Currently, QBE is supported in several relational database front ends, notably Microsoft Access, which implements "Visual Query by Example", as well as Microsoft SQL Server Enterprise Manager. It is also implemented in several object-oriented databases (e.g. in db4o).

QBE is based on the logical formalism called tableau query, although QBE adds some extensions to that, much like SQL is based on the relational algebra.